-- this file should be run on the administration database before deploying the RSS system

declare @localized_string_SystemProps_s_Description_RSS NVARCHAR(64)
set @localized_string_SystemProps_s_Description_RSS  = N'Commerce RSS'
EXEC proc_insert_system_property
  @name               = N'',
  @className          = N'MSCS_RSS',
  @resourceType       = N'Commerce RSS',
  @description        = @localized_string_SystemProps_s_Description_RSS,
  @resourceFlags      = 2,
  @pupFlags           = 1,
  @progidPUP          = N'Commerce.RSSPup'
GO

declare @localized_string_ExtendedProps_s_DisplayName_connstr_db_RSS NVARCHAR(64)
set @localized_string_ExtendedProps_s_DisplayName_connstr_db_RSS = N'RSS: Database Connection String'
declare @localized_string_ExtendedProps_s_Description_connstr_db_RSS NVARCHAR(512)
set @localized_string_ExtendedProps_s_Description_connstr_db_RSS = N'The connection string to the RSS database. This connection string must be unique across all sites. Do not use the same connection string for the RSS resources in other sites.'
EXEC proc_insert_extended_property
    @resourceType         = N'Commerce RSS',
    @propertyName         = N'connstr_db_RSS',
    @isConnectionString   = 1,
    @isHidden             = 0,
    @isSimpleList         = 0,
    @description          = @localized_string_ExtendedProps_s_Description_connstr_db_RSS,
    @varType              = 8,
    @value                = N'',
    @displayName          = @localized_string_ExtendedProps_s_DisplayName_connstr_db_RSS
GO

declare @s_CurrentVersion NVARCHAR(512)
set @s_CurrentVersion  = N'1.0.0'
EXEC proc_insert_extended_property 
    @resourceType         = N'Commerce RSS',
    @propertyName         = N's_ResourceVersion',
    @isConnectionString   = 0,
    @isHidden             = 1,
    @isSimpleList         = 0,
    @description          = N'',
    @varType              = 8,
    @value                = @s_CurrentVersion,
    @displayName          = N's_ResourceVersion'
GO